const express=require("express");
const app=express();
const port=8080;
const users = [ { username: 'admin', password: 'password123' } ];
app.get("/denglu",(req,res)=>{
    let user=users.find(u=>u.username==req.query.uname&& u.password==query.upwd);
    console.log(user)
    if(user){
        //用户名和密码正确
        res.json({code:200,msg:"登录成功"});
    }else{
        //用户名和密码错误
        res.json({code:401,msg:"用户名或密码错误"})
    }
    conn.connect((err)=>{
        if(err){
            console.log("1."+err.message);
        }else{
            console.log("1.连接成功");
        }
    })
});
//定义SQL查询
let sql ="select * from user where username='"+req.query.uname+"'and password ='"+req.query.upwd+"';";
//执行SQL
conn.query(sql,(err,result)=>{
    if(err){
        console.error("2."+err.message);
    }else{
        console.log(result)
        if(result.length>0){
            res.json({code:200,msg:"登录成功"});
        }else{
            res.json({code:401,msg:"用户名或密码错误"});
        }
    }
})
app.listen(port,()=>{
    console.log("监听端口"+port);
});
